TG: sql_for_qa/66

Какой из следующих SQL запросов выведет число сотрудников в каждом отделе, при этом названия отделов должны быть отсортированы в алфавитном порядке

Anonymous Quiz

SELECT department, COUNT() FROM employees ORDER BY department ASC;

SELECT department, COUNT() FROM employees GROUP BY department ORDER BY department ASC;

SELECT department, COUNT() FROM employees GROUP BY department ORDER BY COUNT() ASC;

SELECT department, COUNT(*) FROM employees GROUP BY department ORDER BY department DESC;

655 answered

Create: 2023-03-20
Last Update: 2025-07-02 10:51:04

BY SQL для тестировщика

Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283

Share with your friend now:
tg-me.com/sql_for_qa/66

SQL для тестировщика Telegram | DID YOU KNOW?